 
%include "ASMimplibs.sas";



data cmf02;
 set allcmf.gooddata_all_inds02;
run;


proc sort data= cmf02  nodupkey; by NAICS_NEW_6; run;

data cmf02_inds (keep=number NAICS_NEW_6);
 set cmf02;
 number=_N_;
run;

 PROC EXPORT DATA= cmf02_inds 
  OUTFILE= "all_mfg/cmf02_inds.csv" DBMS=CSV REPLACE;
      PUTNAMES=YES;
 RUN;


data cmf07;
 set allcmf.gooddata_all_inds07;
run;


proc sort data= cmf07  nodupkey; by NAICS_NEW_6; run;

data cmf07_inds (keep=number NAICS_NEW_6);
 set cmf07;
 number=_N_;
run;

 PROC EXPORT DATA= cmf07_inds 
  OUTFILE= "cmf07_inds.csv" DBMS=CSV REPLACE;
      PUTNAMES=YES;
 RUN;
